The University of Texas
CS 327e Fall 2002 Quiz 1
Date: 2002-11-18 Duration:
15 minutes
Total: 100 points, 10 questions. Each question is weighted
equally, and is worth 10 points.
The correct answer is
shown in BOLD.
NAME: ______________________________________ LAST 4 DIGITS
SSN: ________________
1)
Application
programs are often written by companies that use them, but the DBMS is almost
always licensed as a commercial product.
a)
TRUE b) FALSE
2)
The
DBMS is used to create the database itself but not to create the underlying
tables.
a)
TRUE b) FALSE
3)
Outer
Joins can be used to ensure that all rows from a table appear in the result.
a)
TRUE b) FALSE
4)
SELECT
statement results can be sorted using the GROUP BY command.
a)
TRUE b) FALSE
5)
A
weak entity is one whose existence depends on another entity.
a)
TRUE b) FALSE
6)
To
represent the 1:N relationship between 2 tables, we place the PK of the parent
in the child.
a)
TRUE b) FALSE
7)
Concurrency
control, Security, and Reliability are 3 of the major concerns of a DBA.
a)
TRUE b) FALSE
8)
Deadlock:
When 2 transactions (txns) are each waiting on a resource that the other txn
holds.
a)
TRUE b) FALSE
9)
A
view is a virtual table representing a subset of columns and/or rows from one
or more base tables or views.
a)
TRUE b) FALSE
10)
The
main objective of database design is to model the real world.
a)
TRUE b) FALSE